package com.bgIntlgn.client.entity.manufacture;

import java.util.Date;

import yuhuibear.poat.annotations.relation.View;
import yuhuibear.poat.object.bean.Bean;

/**
 * ProductionIterm视图
 * 
 * @author Simon Chen
 */
@View(name = "productionIterm_view", sqlToCreate = "select pi.id as id, pi.uid as uid, pi.plan_id as plan_id, "
		+ "elements.name as name, es.spec as spec, pi.prepared as prepared, pi.plan_quantity as plan_quantity, "
		+ "pi.produced_quantity as produced_quantity, materials.name as materialname, qa_view.broken as broken, "
		+ "pi.dead_line as dead_line "
		+ "from (production_iterms as pi left outer join qa_view on qa_view.productionitermid=pi.id), elements ,element_subversions as es, materials "
		+ "where pi.uid=es.uid and es.element_id=elements.id and es.material_id=materials.id")
public class ProductionItermView implements Bean {

	private Long id;
	private String uid;
	private Long planId;
	private Integer prepared;
	private Integer producedQuantity;
	private Integer planQuantity;
	// 进度
	private double progress;
	private String name;
	private String spec;
	private String materialname;
	private Long broken;
	private Date deadLine;

	public Long getId() {
		return id;
	}

	public void setId(Long id) {
		this.id = id;
	}

	public Long getPlanId() {
		return planId;
	}

	public void setPlanId(Long planId) {
		this.planId = planId;
	}

	public String getUid() {
		return uid;
	}

	public void setUid(String uid) {
		this.uid = uid;
	}

	public double getProgress() {
		return progress;
	}

	public void setProgress(double progress) {
		this.progress = progress;
	}

	public Integer getPrepared() {
		return prepared;
	}

	public void setPrepared(Integer prepared) {
		this.prepared = prepared;
	}

	public Integer getProducedQuantity() {
		return producedQuantity;
	}

	public void setProducedQuantity(Integer producedQuantity) {
		this.producedQuantity = producedQuantity;
	}

	public Integer getPlanQuantity() {
		return planQuantity;
	}

	public void setPlanQuantity(Integer planQuantity) {
		this.planQuantity = planQuantity;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getSpec() {
		return spec;
	}

	public void setSpec(String spec) {
		this.spec = spec;
	}

	public String getMaterialname() {
		return materialname;
	}

	public void setMaterialname(String materialname) {
		this.materialname = materialname;
	}

	public Long getBroken() {
		return broken;
	}

	public void setBroken(Long broken) {
		this.broken = broken;
	}

	public Date getDeadLine() {
		return deadLine;
	}

	public void setDeadLine(Date deadLine) {
		this.deadLine = deadLine;
	}
}